Remove protection and passwords

1. Switch to the protected worksheet.
2. On the Tools menu, point to Protection, and then click Unprotect Sheet.
3. If prompted, enter the protection password for the worksheet.
4. On the Tools menu, point to Protection, and then click Allow Users to Edit Ranges.
5. In the Ranges unlocked by a password when cell is protected list, click the range for which you want to remove permissions.
6. Click Delete.

1. Switch to the protected worksheet.
2. On the Tools menu, point to Protection, and then click Unprotect Sheet.
3. If prompted, enter the protection password for the worksheet.

1. Open the protected workbook.
2. On the Tools menu, point to Protection, and then click Unprotect Workbook.
3. If prompted, enter the protection password for the workbook.

Removing protection when a password is in use also unshares the workbook, disconnecting other users from the workbook and erasing the change history. If no password is in effect, the workbook remains shared after you unprotect it.

1. Open the protected workbook
2. On the Tools menu, point to Protection, and then click Unprotect Shared Workbook.
3. If prompted, enter the password for the workbook.
4. If prompted about the effects on other users of removing protection, click Yes.

1. Open the workbook.
2. On the File menu, click Save As.
3. On the Tools menu, click General Options.
4. In the Password to open or Password to modify box, or both boxes, double-click the asterisks and then press the DELETE key.
5. Click OK, and then click Save.
6. Click Yes to replace the existing workbook.